CREATE PROCEDURE [dbo].[sp_DropView]
   @Database nvarchar(255),
   @Owner nvarchar(255),
   @View nvarchar(255)
AS
BEGIN
   DECLARE @SQLStmt varchar(8000);
   SET NOCOUNT ON;
   SET @SQLStmt = '
      IF  EXISTS (
         SELECT * FROM ' + @Database + '.sys.views
         WHERE
            object_id = OBJECT_ID(N''' + @Database + '.' + @Owner + '.' + @View + ''')
      )
      EXEC ' + @Database + '..sp_executesql N''DROP VIEW ' + @Owner + '.' + @View + '''
      ';
   EXEC (@SQLStmt);
END
GO